﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
/// <summary>
///DBBLL 的摘要说明
/// </summary>
public class DBBLL
{
	public DBBLL()
	{
		//
		//TODO: 在此处添加构造函数逻辑
		//
	}

    public static DataTable GetStudentInfoList()
    {
        string sql = @" select UserID, UserName,FullName,Mobile,Sex,Address, English, Chinese, Math, Jpanese, Other
                        from Student left join Score on Student.id=Score.UserID ";
        return DBHelp.Query(sql);
    }

    public static DataTable GetScoreInfo(int userID)
    {
        string sql = @" select UserID, English, Chinese, Math, Jpanese, Other
                        from Score where userID="+userID+"";
        return DBHelp.Query(sql);
    }
}